<?php
/**
 * 系統名稱: Kacino 系統
 * 檔案說明: 專案管理-修改
 * $Author$
 * $Id$
 *
 */
$_data["Account"] = trim($_data["Account"]);

//=====================================================================================//
//組合查詢SQL
$strSQL = "select a.Account as UAccount, c.Account as CAccount, b.* from `bet_Member` a, `bet_RateChangeRecord` b, `bet_Member` c where a.Account = '".$_data["Account"]."' and a.ID = b.UserID and c.ID = b.ChangeUserID order by b.ID desc limit 0, 500";

//=====================================================================================//
//查詢
if(!$RS = @mysql_query($strSQL, $$_Conn)){
	$GLOBALS["errormessage"] = "Find User Data Error!";
	$GLOBALS["errorhidden"] = "SQL: ".$strSQL.", \nError: ".mysql_error($$_Conn).", \nLine: ".__LINE__.", \nPage: ".__FILE__;
	ErrMsgOutputHTML("Error", "", 1);
}
$arrLogType = array(
	0 => "成數", 
	1 => "信用度", 
	10 => "單場限額", 
	11 => "單注限額", 
	12 => "單場總額", 
	21 => "A盤", 
	22 => "B盤", 
	23 => "C盤");
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="/css/backend.css" type="text/css">
<script language="JavaScript1.2" type="text/javascript" src="/inc/admin_envirset.js"></script>
<script language="JavaScript">
<!--
var strRowClassName = ",datarow,";
//-->
</script>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #F7F7F7;
	font-size: 12px
}
.BetID{
	color: #FF0000;
	font-weight: 700;
}
//-->
</style>
</head>
<body>
<table class="content_b">
<tr>
<td valign="center" style="font-weight: 700; font-size: 16px">資料變更紀錄</td>
<td valign="top" align="right">&nbsp;</td></tr>
<tr>
<td valign="top" colspan="2">
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#0054E3F"><tr><td>
<table width="690" border="0" cellpadding="3" cellspacing="1" style="font-size: 12px">
<tr bgcolor="#7A96E9" align="center">
<td width="40">序號</td>
<td width="60">時間</td>
<td width="60">更改人</td>
<td width="60">帳號</td>
<td width="60">類別</td>
<td width="60">原值1</td>
<td width="60">新值1</td>
<td width="60">原值2</td>
<td width="60">新值2</td>
<td width="80">IP</td>
</tr>
<?php
while($Rows = mysql_fetch_object($RS)){
?>
<tr class="datarow" bgcolor="#FFFFFF">
<td align="left"><?php print $Rows -> ID;?></td>
<td align="left"><?php print $Rows -> ChangeDate;?></td>
<td align="left"><?php print $Rows -> CAccount;?></td>
<td align="left"><?php print $Rows -> UAccount;?></td>
<td align="left"><?php print $arrLogType[$Rows -> LogType];?></td>
<td align="right"><?php print $Rows -> Scale;?></td>
<td align="right"><?php print $Rows -> NewScale;?></td>
<td align="right"><?php print $Rows -> MainScale;?></td>
<td align="right"><?php print $Rows -> NewMainScale;?></td>
<td align="left"><?php print $Rows -> IP;?></td>
</tr>
<?php
}  //while($Rows -> mysql_fetch_object($RS)){//
?>
<tr bgcolor="#FFFFFF" align="right">
<td colspan="10">共計 <?php print mysql_num_rows($RS);?> 筆</td>
</tr>
</table>
</td></tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
(ps. 以上最多呈現 500筆資料)
</body>
</html>